

set more off

preserve

putexcel set tab5.xlsx, sheet(sheet1) replace

putexcel A1 = "Table 5: Vote shares and candidate favorability ratings, by electoral race."

putexcel A2 = "Candidate "
putexcel A3 = ""
putexcel A4 = ""
putexcel A5 = ""
putexcel A6 = "--------"
putexcel A7 = "Mayor race"
putexcel A8 = "A* "
putexcel A9 = "B "
putexcel A10 = "Vice-mayor race"
putexcel A11 = "C "
putexcel A12 = "D "
putexcel A13 = "E "
putexcel A14 = "City council race, Bacon District"
putexcel A15 = "F "
putexcel A16 = "G "
putexcel A17 = "H* "
putexcel A18 = "I "
putexcel A19 = "J "
putexcel A20 = "K "
putexcel A21 = "L* "
putexcel A22 = "M "
putexcel A23 = "N "
putexcel A24 = "O* "
putexcel A25 = "P "
putexcel A26 = "City council race, East District"
putexcel A27 = "Q* "
putexcel A28 = "R* "
putexcel A29 = "S "
putexcel A30 = "T* "
putexcel A31 = "U "
putexcel A32 = "V "
putexcel A33 = "W "
putexcel A34 = "X "
putexcel A35 = "Y "
putexcel A36 = "Z "
putexcel A37 = "AA "
putexcel A38 = "AB "
putexcel A39 = "AC "
putexcel A40 = "City council race, West District"
putexcel A41 = "AD "
putexcel A42 = "AE "
putexcel A43 = "AF* "
putexcel A44 = "AG "
putexcel A45 = "AH "
putexcel A46 = "AI "
putexcel A47 = "AJ* "
putexcel A48 = "AK "
putexcel A49 = "AL* "
putexcel A50 = "AM "
putexcel A51 = "AN "
putexcel A52 = "AO "

putexcel B2 = " Actual vote  "
putexcel B3 = " share in  "
putexcel B4 = " election "
putexcel B5 = " "
putexcel B6 = ""
putexcel B7 = ""
putexcel B8 = "46.3"
putexcel B9 = "48"
putexcel B10 = ""
putexcel B11 = "30"
putexcel B12 = "24.6"
putexcel B13 = "32.9"
putexcel B14 = ""
putexcel B15 = "30.4"
putexcel B16 = "24.5"
putexcel B17 = "37.8"
putexcel B18 = "10.2"
putexcel B19 = "32.7"
putexcel B20 = "32.5"
putexcel B21 = "37.3"
putexcel B22 = "15.8"
putexcel B23 = "17.1"
putexcel B24 = "25.5"
putexcel B25 = "20.1"
putexcel B26 = ""
putexcel B27 = "31.3"
putexcel B28 = "20.4"
putexcel B29 = "6.6"
putexcel B30 = "29.7"
putexcel B31 = "3.2"
putexcel B32 = "5.5"
putexcel B33 = "40.5"
putexcel B34 = "45.4"
putexcel B35 = "44.4"
putexcel B36 = "34.5"
putexcel B37 = "15.1"
putexcel B38 = "9.2"
putexcel B39 = "18.2"
putexcel B40 = ""
putexcel B41 = "5"
putexcel B42 = "20.1"
putexcel B43 = "49.8"
putexcel B44 = "32.7"
putexcel B45 = "18.2"
putexcel B46 = "37.3"
putexcel B47 = "38.4"
putexcel B48 = "27.4"
putexcel B49 = "34.6"
putexcel B50 = "3.1"
putexcel B51 = "9.7"
putexcel B52 = "8.3"

putexcel C2 = " Reported  "
putexcel C3 = " vote share  "
putexcel C4 = " (endline  "
putexcel C5 = " survey) "
putexcel C6 = ""
putexcel C7 = ""
putexcel C8 = "44.8"
putexcel C9 = "55.2"
putexcel C10 = ""
putexcel C11 = "30.2"
putexcel C12 = "23.4"
putexcel C13 = "46.5"
putexcel C14 = ""
putexcel C15 = "31"
putexcel C16 = "24.5"
putexcel C17 = "46"
putexcel C18 = "11.1"
putexcel C19 = "44.4"
putexcel C20 = "39.9"
putexcel C21 = "54"
putexcel C22 = "17.6"
putexcel C23 = "18.8"
putexcel C24 = "24.9"
putexcel C25 = "14.6"
putexcel C26 = ""
putexcel C27 = "28.7"
putexcel C28 = "23"
putexcel C29 = "4.6"
putexcel C30 = "33"
putexcel C31 = "1.5"
putexcel C32 = "1.2"
putexcel C33 = "60.2"
putexcel C34 = "60.2"
putexcel C35 = "54"
putexcel C36 = "39.5"
putexcel C37 = "13.8"
putexcel C38 = "4.2"
putexcel C39 = "11.9"
putexcel C40 = ""
putexcel C41 = "4.2"
putexcel C42 = "13.4"
putexcel C43 = "60.8"
putexcel C44 = "43.8"
putexcel C45 = "19.1"
putexcel C46 = "50.9"
putexcel C47 = "59"
putexcel C48 = "23.7"
putexcel C49 = "50.9"
putexcel C50 = "4.2"
putexcel C51 = "7.4"
putexcel C52 = "4.6"

putexcel D2 = " Sample  "
putexcel D3 = " vote share  "
putexcel D4 = " (endline  "
putexcel D5 = " survey) "
putexcel D6 = ""
putexcel D7 = ""
putexcel D8 = "44.8"
putexcel D9 = "55.2"
putexcel D10 = ""
putexcel D11 = "30.2"
putexcel D12 = "23.4"
putexcel D13 = "46.5"
putexcel D14 = ""
putexcel D15 = "31"
putexcel D16 = "24.5"
putexcel D17 = "46"
putexcel D18 = "11.1"
putexcel D19 = "44.4"
putexcel D20 = "39.9"
putexcel D21 = "54"
putexcel D22 = "17.6"
putexcel D23 = "18.8"
putexcel D24 = "24.9"
putexcel D25 = "14.6"
putexcel D26 = ""
putexcel D27 = "28.7"
putexcel D28 = "23"
putexcel D29 = "4.6"
putexcel D30 = "33"
putexcel D31 = "1.5"
putexcel D32 = "1.2"
putexcel D33 = "60.2"
putexcel D34 = "60.2"
putexcel D35 = "54"
putexcel D36 = "39.5"
putexcel D37 = "13.8"
putexcel D38 = "4.2"
putexcel D39 = "11.9"
putexcel D40 = ""
putexcel D41 = "4.2"
putexcel D42 = "13.4"
putexcel D43 = "60.8"
putexcel D44 = "43.8"
putexcel D45 = "19.1"
putexcel D46 = "50.9"
putexcel D47 = "59"
putexcel D48 = "23.7"
putexcel D49 = "50.9"
putexcel D50 = "4.2"
putexcel D51 = "7.4"
putexcel D52 = "4.6"



restore
